home *** CD-ROM | disk | FTP | other *** search
/ Komputer for Alle 1999 #5 / 1999 CD 5 (black).iso / Delphi3 / install / data.z / DBX.DBI < prev    next >
Encoding:
Borland DataBase Explorer Information  |  1997-08-05  |  35.5 KB  |  787 lines
  1.  
  2.  
  3. [Version]
  4. DbXName="Database Explorer"
  5. DbXVersion=3.00
  6.  
  7. [Properties]
  8. DEFAULT DRIVER:Values=Closed,PARADOX,DBASE,ASCIIDRV
  9. NET PROTOCOL:Values1=Closed,TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  10. NET PROTOCOL:Values2=APPC,ASYNC
  11. OPEN MODE:Values=Closed,READ/WRITE,READ ONLY
  12. SHARE MODE:Values=Closed,EXCLUSIVE,SHARED
  13. STRICTINTEGRTY:Values=Closed,FALSE,TRUE
  14. SQLPASSTHRU MODE:Values=Closed,NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  15. LIST SYNONYMS:Values=Closed,NONE,ALL,PRIVATE
  16. BLOB EDIT LOGGING:Values=Closed,FALSE,TRUE
  17. ENABLE SCHEMA CACHE:Values=Closed,FALSE,TRUE
  18. ENABLE BCD:Values=Closed,FALSE,TRUE
  19. ENABLE INTEGERS:Values=Closed,FALSE,TRUE
  20. LOCAL SHARE:Values=Closed,FALSE,TRUE
  21. AUTO ODBC:Values=Closed,FALSE,TRUE
  22. FOURDIGITYEAR:Values=Closed,FALSE,TRUE
  23. YEARBIASED:Values=Closed,FALSE,TRUE
  24. LEADINGZEROM:Values=Closed,FALSE,TRUE
  25. LEADINGZEROD:Values=Closed,FALSE,TRUE
  26. TWELVEHOUR:Values=Closed,FALSE,TRUE
  27. SECONDS:Values=Closed,FALSE,TRUE
  28. MILSECONDS:Values=Closed,FALSE,TRUE
  29. LEADINGZERON:Values=Closed,FALSE,TRUE
  30. COLLCHAR:Values=Closed,0,1,2
  31. DBNLS:Values=Closed,0,1,2
  32. SQLQRYMODE:Values=Closed,LOCAL,SERVER
  33.  
  34. :HelpContext=4039
  35. DB2:HelpContext=4038
  36. INFORMIX:HelpContext=4035
  37. INTRBASE:HelpContext=4037
  38. MSACCESS:HelpContext=4042
  39. MSSQL:HelpContext=4036
  40. ORACLE:HelpContext=4034
  41. STANDARD:HelpContext=4045
  42. SYBASE:HelpContext=4033
  43.  
  44.  
  45.  
  46. [STANDARD Properties]
  47. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  48. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  49. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  50. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  51. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  52. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  53. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  54. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  55. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  56. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  57. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  58. FamilyMemberType:Values1=Closed,0="Unknown",1="Table",2="Index",3="Form",4="Report"
  59. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  60. FamilyMemberType:Values3=8="Blob File"
  61.  
  62. STANDARD:Objects=O:C:0M::"Tables":Table
  63.  
  64. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  65. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  66. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  67. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  68. Table:Dataset5=PROTECTED=Word,VALID=Word
  69.  
  70. Table:Category=Dataset
  71. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  72. Table:Attrs2=DATE="Date"
  73. Table:Attrs3=TIME="Time"
  74. Table:Attrs4=VERSION="Version":2
  75. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  76. Table:Attrs6=STRUCTURE="Structure":2
  77. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  78. Table:Name=FILENAME,EXTENSION
  79. Table:Objects1=O:P:1M::"Fields":Column
  80. Table:Objects2=O:O:0M::"Indices":Index
  81. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  82. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  83. Table:Objects5=O:O:0M::"Security Specs":Security
  84. Table:Objects6=O:C:1M::"Family Members":Family
  85.  
  86. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  87. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  88. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  89.  
  90. Column:Category=Column
  91. Column:Order=FIELDNUM
  92. Column:Attrs1=FIELDNUM="Order":2:NR
  93. Column:Attrs2=TYPE="Type":1:NR
  94. Column:Attrs3=UNITS1="Size":1:N
  95. Column:Attrs4=UNITS2="Scale":1:N
  96. Column:Attrs5=LENGTH="Physical Length"
  97. Column:Name=NAME
  98.  
  99. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  100. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  101. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  102. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  103. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  104. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  105.  
  106. Index:Category=Index
  107. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  108. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  109. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  110. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  111. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  112. Index:Attrs6=FORMAT="Format":2
  113. Index:Attrs7=BLOCKSIZE="Block Size":2
  114. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  115. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  116. Index:Attrs10=EXPRESSION="Expression":2:N
  117. Index:Attrs11=CONDITION="Subset Condition":2:N
  118. Index:Name=NAME
  119. Index:OnAfterLoad=GetIndexInfo
  120.  
  121. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  122. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  123. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  124. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  125.  
  126. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  127. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  128. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  129. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  130. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  131. ValCheck:Attrs6=PICTURE="Picture":2:N
  132. ValCheck:Name=FIELDNUM
  133.  
  134. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  135.  
  136. Family:Attrs1=TYPE="Type":1::::VM=FamilyMemberType
  137. Family:Attrs2=NAME="Object Name":1
  138. Family:Name=FILENAME
  139.  
  140. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  141. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  142. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  143.  
  144. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  145. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  146. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  147. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  148. Reference:Name=NAME
  149. Reference:OnAfterLoad=GetReferenceInfo
  150.  
  151. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  152. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  153.  
  154. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  155. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  156. Security:Name=PASSWORD
  157.  
  158. [MSACCESS Properties]
  159. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  160. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  161. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  162. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  163. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  164. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  165. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  166. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  167. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  168. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  169. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  170.  
  171. MSACCESS:Objects1=O:C:0M::"Tables":Table
  172. MSACCESS:Objects2=O:C:0M::"Procedures":Procedure
  173.  
  174. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  175. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  176. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  177. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  178. Table:Dataset5=PROTECTED=Word,VALID=Word
  179.  
  180. Table:Category=Dataset
  181. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  182. Table:Attrs2=DATE="Date"
  183. Table:Attrs3=TIME="Time"
  184. Table:Attrs4=VERSION="Version":2
  185. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  186. Table:Attrs6=STRUCTURE="Structure":2
  187. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  188. Table:Name=FILENAME,EXTENSION
  189. Table:Objects1=O:P:1M::"Fields":Column
  190. Table:Objects2=O:O:0M::"Indices":Index
  191. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  192. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  193. Table:Objects5=O:O:0M::"Security Specs":Security
  194.  
  195. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  196. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  197. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  198.  
  199. Column:Category=Column
  200. Column:Order=FIELDNUM
  201. Column:Attrs1=FIELDNUM="Order":2:NR
  202. Column:Attrs2=TYPE="Type":1:NR
  203. Column:Attrs3=UNITS1="Size":1:N
  204. Column:Attrs4=UNITS2="Scale":1:N
  205. Column:Attrs5=LENGTH="Physical Length"
  206. Column:Name=NAME
  207.  
  208. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  209. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  210. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  211. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  212. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  213. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  214.  
  215. Index:Category=Index
  216. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  217. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  218. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  219. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  220. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  221. Index:Attrs6=FORMAT="Format":2
  222. Index:Attrs7=BLOCKSIZE="Block Size":2
  223. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  224. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  225. Index:Attrs10=EXPRESSION="Expression":2:N
  226. Index:Attrs11=CONDITION="Subset Condition":2:N
  227. Index:Name=NAME
  228. Index:OnAfterLoad=GetIndexInfo
  229.  
  230. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  231. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  232. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  233. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  234.  
  235. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  236. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  237. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  238. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  239. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  240. ValCheck:Attrs6=PICTURE="Picture":2:N
  241. ValCheck:Name=FIELDNUM
  242.  
  243. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  244. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  245. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  246.  
  247. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  248. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  249. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  250. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  251. Reference:Name=NAME
  252. Reference:OnAfterLoad=GetReferenceInfo
  253.  
  254. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  255. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  256.  
  257. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  258. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  259. Security:Name=PASSWORD
  260.  
  261. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  262.  
  263. Procedure:Category=Executable
  264. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  265. Procedure:EAttrs=Data
  266. Procedure:Name=NAME
  267.  
  268. [ODBC Properties]
  269. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase"
  270. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  271. FieldVChecks:Values=Closed,0=,1="Has Validity Checks",2=
  272. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=
  273. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  274. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  275. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  276. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  277. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  278. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  279. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  280.  
  281. ODBC:Objects1=O:C:0M::"Tables":Table
  282. ODBC:Objects2=O:C:0M::"Procedures":Procedure
  283.  
  284. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  285. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  286. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  287. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  288. Table:Dataset5=PROTECTED=Word,VALID=Word
  289.  
  290. Table:Category=Dataset
  291. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  292. Table:Attrs2=DATE="Date"
  293. Table:Attrs3=TIME="Time"
  294. Table:Attrs4=VERSION="Version":2
  295. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  296. Table:Attrs6=STRUCTURE="Structure":2
  297. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  298. Table:Name=FILENAME,EXTENSION
  299. Table:Objects1=O:P:1M::"Fields":Column
  300. Table:Objects2=O:O:0M::"Indices":Index
  301. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  302. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  303. Table:Objects5=O:O:0M::"Security Specs":Security
  304.  
  305. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  306. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  307. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  308.  
  309. Column:Category=Column
  310. Column:Order=FIELDNUM
  311. Column:Attrs1=FIELDNUM="Order":2:NR
  312. Column:Attrs2=TYPE="Type":1:NR
  313. Column:Attrs3=UNITS1="Size":1:N
  314. Column:Attrs4=UNITS2="Scale":1:N
  315. Column:Attrs5=LENGTH="Physical Length"
  316. Column:Name=NAME
  317.  
  318. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  319. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  320. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  321. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  322. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  323. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  324.  
  325. Index:Category=Index
  326. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  327. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  328. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  329. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  330. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  331. Index:Attrs6=FORMAT="Format":2
  332. Index:Attrs7=BLOCKSIZE="Block Size":2
  333. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  334. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  335. Index:Attrs10=EXPRESSION="Expression":2:N
  336. Index:Attrs11=CONDITION="Subset Condition":2:N
  337. Index:Name=NAME
  338. Index:OnAfterLoad=GetIndexInfo
  339.  
  340. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  341. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  342. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  343. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  344.  
  345. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  346. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  347. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  348. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  349. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  350. ValCheck:Attrs6=PICTURE="Picture":2:N
  351. ValCheck:Name=FIELDNUM
  352.  
  353. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  354. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  355. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  356.  
  357. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  358. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  359. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  360. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  361. Reference:Name=NAME
  362. Reference:OnAfterLoad=GetReferenceInfo
  363.  
  364. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  365. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  366.  
  367. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  368. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  369. Security:Name=PASSWORD
  370.  
  371. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  372.  
  373. Procedure:Category=Executable
  374. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  375. Procedure:EAttrs=Data
  376. Procedure:Name=NAME
  377.  
  378.  
  379.  
  380.  
  381. [INTRBASE Properties]
  382. TFieldType:Values1=Closed,7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  383. TFieldType:Values2=11=DOUBLE PRECISION,14=`'CHAR('=Length')'`:CHAR,27=NUMERIC
  384. TFieldType:Values3=35=DATE,37=`'VARCHAR('=Length')'`:VARCHAR
  385. TFieldType:Values4=40=`'CSTRING('=Length')'`:CSTRING
  386. TFieldType:Values5=261=`'BLOB'``!' SUB_TYPE ' =SubType`:BLOB
  387. TFieldSubType:Values1=Closed,0=0:,1=1:"Text",2=2:"BLR",3=3:"ACL",4=4:"Ranges",5=5:"Summary"
  388. TFieldSubType:Values2=6=6:"Format",7=7:"Transaction Desc",8=8:"Ext File Desc"
  389. TNulls:Values=Closed,=:"Yes",1=NOT NULL:"No"
  390. TUniqueIndex:Values=Closed,=:"No",0=:"No",1=UNIQUE:"Yes"
  391. TDescendingIndex:Values=Closed,=ASCENDING:"No",1=DESCENDING:"Yes"
  392. TTriggerType:Values1=Closed,1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  393. TTriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  394. TParamKind:Values=Closed,0=:"Input",1=:"Output"
  395. TFnParamKind:Values=Closed,0=BY VALUE:"Value",1=:"Reference",3=:"Handle"
  396.  
  397. INTRBASE:Comments=/*,*/
  398.  
  399. INTRBASE:Objects1=O:C:0M::"Domains":Type
  400. INTRBASE:Objects2=O:C:0M::"Tables":Table
  401. INTRBASE:Objects3=O:C:0M::"Views":View
  402. INTRBASE:Objects4=O:C:0M::"Procedures":Procedure
  403. INTRBASE:Objects5=O:C:0M::"Functions":Function
  404. INTRBASE:Objects6=O:C:0M::"Generators":Generator
  405. INTRBASE:Objects7=O:C:0M::"Exceptions":Exception
  406. INTRBASE:Objects8=O:C:0M::"Blob Filters":BlobFilter
  407.  
  408. RDB$RELATIONS:Name=RDB$RELATION_NAME
  409. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner"
  410. RDB$RELATIONS:Attrs2=RDB$DESCRIPTION="Description"
  411. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  412.  
  413. RDB$RELATION_FIELDS:Key=RDB$RELATION_NAME,RDB$FIELD_NAME
  414. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  415. RDB$RELATION_FIELDS:Order=RDB$FIELD_POSITION
  416. RDB$RELATION_FIELDS:Objects=P:R:M1::"Domain":Type
  417. RDB$RELATION_FIELDS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  418. RDB$RELATION_FIELDS:Attrs2=RDB$DEFAULT_SOURCE=Default="Default"::E
  419. RDB$RELATION_FIELDS:Attrs3=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  420. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE
  421.  
  422. RDB$FIELDS:Name=RDB$FIELD_NAME
  423. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  424. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  425. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH=Length="Length"::E
  426. RDB$FIELDS:Attrs4=RDB$FIELD_SCALE=Scale="Scale"::E
  427. RDB$FIELDS:Attrs5=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  428. RDB$FIELDS:Attrs6=RDB$SEGMENT_LENGTH=SegmentSize="Segment Size":2:E
  429. RDB$FIELDS:Attrs7=RDB$DEFAULT_SOURCE=Default="Default":2:E
  430. RDB$FIELDS:Attrs8=RDB$VALIDATION_SOURCE=Rule="Constraint":2:E
  431. RDB$FIELDS:Attrs9=RDB$DESCRIPTION=Description="Description"
  432.  
  433. RDB$FIELD_DIMENSIONS:Key=RDB$FIELD_NAME,RDB$DIMENSION
  434. RDB$FIELD_DIMENSIONS:Name=RDB$DIMENSION
  435. RDB$FIELD_DIMENSIONS:Order=RDB$DIMENSION
  436. RDB$FIELD_DIMENSIONS:Attrs1=RDB$DIMENSION="Order":2:ER
  437. RDB$FIELD_DIMENSIONS:Attrs2=RDB$LOWER_BOUND=LowerBound="Lower Bound"::ER
  438. RDB$FIELD_DIMENSIONS:Attrs3=RDB$UPPER_BOUND=UpperBound="Upper Bound"::ER
  439.  
  440. RDB$FUNCTIONS:Name=RDB$FUNCTION_NAME
  441. RDB$FUNCTIONS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  442. RDB$FUNCTIONS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  443. RDB$FUNCTIONS:Attrs3=RDB$QUERY_NAME=AlternateName="Alternate Name"
  444. RDB$FUNCTIONS:Attrs4=RDB$DESCRIPTION=Description="Description":2
  445. RDB$FUNCTIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  446.  
  447. RDB$FUNCTION_ARGUMENTS:Key=RDB$FUNCTION_NAME,RDB$ARGUMENT_POSITION
  448. RDB$FUNCTION_ARGUMENTS:Name=RDB$ARGUMENT_POSITION
  449. RDB$FUNCTION_ARGUMENTS:Order=RDB$ARGUMENT_POSITION
  450. RDB$FUNCTION_ARGUMENTS:Attrs1=RDB$ARGUMENT_POSITION="Order":2:ER
  451. RDB$FUNCTION_ARGUMENTS:Attrs2=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  452. RDB$FUNCTION_ARGUMENTS:Attrs3=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  453. RDB$FUNCTION_ARGUMENTS:Attrs4=RDB$FIELD_LENGTH=Length="Length"::E
  454. RDB$FUNCTION_ARGUMENTS:Attrs5=RDB$FIELD_SCALE=Scale="Scale"::E
  455.  
  456. RDB$FILTERS:Name=RDB$FUNCTION_NAME
  457. RDB$FILTERS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  458. RDB$FILTERS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  459. RDB$FILTERS:Attrs3=RDB$INPUT_SUB_TYPE=InputType="Input"::ER:::VM=TFieldSubType
  460. RDB$FILTERS:Attrs4=RDB$OUTPUT_SUB_TYPE=OutputType="Output"::ER:::VM=TFieldSubType
  461. RDB$FILTERS:Attrs5=RDB$DESCRIPTION=Description="Description":2
  462. RDB$FILTERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  463.  
  464. RDB$INDICES:Name=RDB$INDEX_NAME
  465. RDB$INDICES:Objects=T:P:1M::"Columns":IndexColumn
  466. RDB$INDICES:Attrs1=RDB$UNIQUE_FLAG=Unique="Unique"::E:::VM=TUniqueIndex
  467. RDB$INDICES:Attrs2=RDB$INDEX_TYPE=Descending="Descending"::E:::VM=TDescendingIndex
  468. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  469.  
  470. RDB$INDEX_SEGMENTS:Key=RDB$INDEX_NAME,RDB$FIELD_NAME
  471. RDB$INDEX_SEGMENTS:Name=Column
  472. RDB$INDEX_SEGMENTS:Order=RDB$FIELD_POSITION
  473. RDB$INDEX_SEGMENTS:Objects1=P:R:M1::"Column":Column:<<>Column
  474. RDB$INDEX_SEGMENTS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  475. RDB$INDEX_SEGMENTS:Reference:"Column"=,RDB$FIELD_NAME
  476.  
  477. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  478. RDB$PROCEDURES:Attrs1=RDB$OWNER_NAME="Owner"
  479. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  480.  
  481. RDB$PROCEDURE_PARAMETERS:Key=RDB$PROCEDURE_NAME,RDB$PARAMETER_NAME
  482. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  483. RDB$PROCEDURE_PARAMETERS:Order=RDB$PARAMETER_NUMBER
  484. RDB$PROCEDURE_PARAMETERS:Objects=P:R:M1::"Domain":Type
  485. RDB$PROCEDURE_PARAMETERS:Attrs1=RDB$PARAMETER_NUMBER="Order":2
  486. RDB$PROCEDURE_PARAMETERS:Attrs2=RDB$PARAMETER_TYPE=Kind="Kind":1:ER:::VM=TParamKind
  487. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE
  488.  
  489. RDB$TYPES:Key=RDB$FIELD_NAME,RDB$TYPE
  490. RDB$TYPES:Name=RDB$TYPE_NAME
  491. RDB$TYPES:Order=RDB$TYPE
  492. RDB$TYPES:Attrs=RDB$TYPE="Value"
  493.  
  494. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  495. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  496.  
  497. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  498. RDB$EXCEPTIONS:Attrs1=RDB$MESSAGE=Message="Message"::E
  499.  
  500. RDB$TRIGGERS:Key=RDB$RELATION_NAME,RDB$TRIGGER_NAME
  501. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  502. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE=Type="Type"::ER:::VM=TTriggerType
  503. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE=Position="Position"::ER
  504. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  505.  
  506. RDB$RELATION_CONSTRAINTS:Key=RDB$RELATION_NAME,RDB$CONSTRAINT_NAME
  507. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  508. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  509. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  510. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME
  511.  
  512. RDB$REF_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  513. RDB$REF_CONSTRAINTS:Objects1=P:R:01::"Primary Key":PrimaryKey
  514. RDB$REF_CONSTRAINTS:Objects2=P:R:11::"Foreign Key":ForeignKey
  515. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  516. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  517. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  518. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  519. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  520. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  521. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  522.  
  523. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  524. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  525.  
  526. Table:Definition=Root=RDB$RELATIONS
  527. View:Definition=Root=RDB$RELATIONS
  528. Procedure:Definition=Root=RDB$PROCEDURES
  529. Function:Definition=Root=RDB$FUNCTIONS
  530. Trigger:Definition=Root=RDB$TRIGGERS
  531. PrimaryKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  532. ForeignKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  533. UniqueConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  534. CheckConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  535. Exception:Definition=Root=RDB$EXCEPTIONS
  536. Generator:Definition=Root=RDB$GENERATORS
  537. Index:Definition=Root=RDB$INDICES
  538. IndexColumn:Definition=Root=RDB$INDEX_SEGMENTS
  539. Column:Definition=Root=RDB$RELATION_FIELDS
  540. Type:Definition=Root=RDB$FIELDS
  541. Enumeration:Definition=Root=RDB$TYPES
  542. Parameter:Definition=Root=RDB$PROCEDURE_PARAMETERS
  543. FunctionParameter:Definition=Root=RDB$FUNCTION_ARGUMENTS
  544. FunctionResult:Definition=Root=RDB$FUNCTION_ARGUMENTS
  545. BlobFilter:Definition=Root=RDB$FILTERS
  546. Dimension:Definition=Root=RDB$FIELD_DIMENSIONS
  547.  
  548. Exception:Warning=Loss
  549. Exception:EAttrs=Text,New,Delete,Modify,Rename,Save
  550. Exception:Text:Get=CREATE EXCEPTION `\N '  ' N \N`  "`=Message`"
  551. Exception:Text:RE=CREATE EXCEPTION\_+(\w+)\_+"(.*)"
  552. Exception:Text:Set=*N=1,Message=2
  553. Exception:Delete:Text=DROP EXCEPTION `O`
  554.  
  555. Generator:Attrs:Q=gen_id=Integer::"Current Value":2:ER
  556. Generator:AttrReference:gen_id=select distinct gen_id(`O`, 0) from RDB$GENERATORS
  557. Generator:Warning=Loss
  558. Generator:EAttrs=Text,New:';',Delete,Modify,Rename,Save
  559. Generator:Text:Init1=CREATE GENERATOR `EDefaultName ';' \N`
  560. Generator:Text:Init2=SET GENERATOR `EDefaultName` TO 0
  561. Generator:Text:Get=CREATE GENERATOR `N`;`\N 'SET GENERATOR ' N ' TO ' =gen_id`
  562. Generator:Text:RE=CREATE GENERATOR\_+(\w+);(\_*SET GENERATOR \w+ TO (\w*))?\_*$
  563. Generator:Text:Set=*N=1,gen_id=3
  564. Generator:Delete:Text1=DELETE FROM RDB$GENERATORS
  565. Generator:Delete:Text2=WHERE RDB$GENERATOR_NAME=`OQ`
  566.  
  567. Table:Category=Dataset
  568. Table:Values=A.RDB$VIEW_SOURCE IS NULL
  569. Table:Objects1=T:P:1M::"Columns":Column
  570. Table:Objects2=T:O:0M::"Indices":Index
  571. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  572. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  573. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  574. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  575. Table:Objects7=T:O:0M::"Triggers":Trigger
  576. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  577. Table:Warning=DataLoss
  578. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  579. Table:Text:Get=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  580. Table:Text:RE=CREATE TABLE\_+(\w+)\_*(\(.*\))
  581. Table:Text:Set=*N=1
  582. Table:Delete:Text=DROP TABLE `O`
  583.  
  584. View:Category=Dataset
  585. View:Values=A.RDB$VIEW_SOURCE IS NOT NULL
  586. View:Objects=T:P:0M:NMDR:"Columns":Column
  587. View:Attrs:Q=Text=Memo::"Text"::ER
  588. View:AttrReference:Text1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  589. View:AttrReference:Text2=where RDB$RELATION_ID=`:RDB$RELATION_ID`
  590. View:Warning=Loss
  591. View:EAttrs=Data,Text,New,Modify,Rename,Delete,Save
  592. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  593. View:Text:Get=CREATE VIEW `N` `'('[Column:%s,%s:\N '  ' N] \N ') '`AS`=Text`
  594. View:Text:RE=CREATE VIEW\_+(\w+)\_*(\(.*\))?\_+AS(.*)
  595. View:Text:Set=Text=3,*N=1
  596. View:Delete:Text=DROP VIEW `O`
  597.  
  598. Index:Category=Index
  599. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  600. Index:Text:Get1=CREATE `!=Unique ' ' ``!=Descending ' ' `INDEX `N`
  601. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:*]`)
  602. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  603. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  604. Index:Delete:Text=DROP INDEX `O`
  605.  
  606. Column:Category=Column
  607. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:E::PResetType
  608. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:E::PResetType
  609. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:E::PResetType
  610. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:E::PResetType
  611. Column:Attrs:R=Type:"Domain":"Type":1:E::PSetType
  612. Column:OnAfterLoad=ColumnLoaded
  613. Column:OnCopyFrom=CopyWithDomain
  614. Column:AttrReference:FieldType=RDB$FIELD_SOURCE
  615. Column:AttrReference:SubType=RDB$FIELD_SOURCE
  616. Column:AttrReference:Length=RDB$FIELD_SOURCE
  617. Column:AttrReference:Scale=RDB$FIELD_SOURCE
  618. Column:EAttrs=Text,New,Delete,Modify,Rename
  619. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  620.  
  621. IndexColumn:Category=ColumnReference
  622. IndexColumn:Attrs:R=Column:::2:ER
  623. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  624. IndexColumn:Text:Get=`N`
  625.  
  626. Type:Category=Type
  627. Type:Objects1=T:P:0M::"Dimensions":Dimension
  628. Type:Objects2=T:C:0M::"Values":Enumeration
  629. ; Convert DEFAULT (.*) in Default and CHECK \((.*)\) in Rule
  630. Type:OnAfterLoad=TypeLoaded
  631. Type:Reference:"Dimensions":Text=`' [' [Dimension:%s, %s:*] ']'`
  632. Type:Warning=Loss
  633. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  634. Type:Text:Get1=CREATE DOMAIN `N` AS` \N '  ' EPhysicalType`
  635. Type:Text:Get2=`!\N '  DEFAULT '=Default`
  636. Type:Text:Get3=`!\N '  ' =Null`
  637. Type:Text:Get4=`!\N '  CHECK (' =Rule ')'`
  638. Type:Delete:Text=DROP DOMAIN `O`
  639.  
  640. Dimension:EAttrs=Text,New,Delete,Modify,Rename
  641. Dimension:Text:Get=`=LowerBound ':' =UpperBound`
  642.  
  643. Procedure:Category=Executable
  644. Procedure:Objects=T:P:0M::"Parameters":Parameter
  645. Procedure:Reference:"Parameters":Text1=`!'(' \N {>Parameter} EParametersIn \N')'`
  646. Procedure:Reference:"Parameters":Text2=`!'RETURNS (' \N {>Parameter} EParametersOut \N ')'`
  647. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  648. Procedure:AttrReference:Text1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  649. Procedure:AttrReference:Text2=where RDB$PROCEDURE_NAME=`OQ`
  650. Procedure:Warning=Loss
  651. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  652. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS`\N`BEGIN`\N`END
  653. Procedure:Text:Get1=CREATE PROCEDURE `N`
  654. Procedure:Text:Get2=`{>Parameter} *`
  655. Procedure:Text:Get3=AS `=Text`
  656. Procedure:Text:RE=CREATE PROCEDURE\_+(\w+)\_*(.*)\_AS\_(.*)
  657. Procedure:Text:Set=Text=3,*>Parameter=2,*N=1
  658. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  659. Procedure:Modify:Set=1=`'ALTER'`
  660. Procedure:Delete:Text=DROP PROCEDURE `O`
  661.  
  662. Parameter:Category=Column
  663. Parameter:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:-E::PResetType
  664. Parameter:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:-E::PResetType
  665. Parameter:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:-E::PResetType
  666. Parameter:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:-E::PResetType
  667. Parameter:Attrs:R=Type:"Domain":"Type":1:::PSetType
  668. Parameter:AttrReference:FieldType=RDB$FIELD_SOURCE
  669. Parameter:AttrReference:SubType=RDB$FIELD_SOURCE
  670. Parameter:AttrReference:Length=RDB$FIELD_SOURCE
  671. Parameter:AttrReference:Scale=RDB$FIELD_SOURCE
  672. Parameter:EAttrs=Text
  673. Parameter:Text:Get=`N ' ' EType`
  674. Parameter:OnAfterLoad=AdjustTypeInfo
  675. Parameter:OnCopyFrom=CopyWithDomain
  676.  
  677. Function:Category=Executable
  678. Function:Objects1=T:P:0M::"Parameters":FunctionParameter
  679. Function:Objects2=T:P:11::"Result":FunctionResult
  680. Function:Reference:"Parameters":Text=`[FunctionParameter:%s, %s:*]`
  681. Function:Reference:"Result":Text=`[FunctionResult::*]`
  682. Function:Warning=Loss
  683. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  684. Function:Text:Get1=DECLARE EXTERNAL FUNCTION `N \N`
  685. Function:Text:Get2=`!'  ' {>FunctionParameter} * \N`
  686. Function:Text:Get3=`'  RETURNS ' {>FunctionResult} * \N`
  687. Function:Text:Get4= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  688. Function:Delete:Text=DROP EXTERNAL FUNCTION `O`
  689.  
  690. FunctionParameter:Category=Column
  691. FunctionParameter:Values=A.RDB$ARGUMENT_POSITION <> `:RDB$RETURN_ARGUMENT`
  692. FunctionParameter:EAttrs=Text,New,Delete,Modify,Rename
  693. FunctionParameter:Text:Get=`EPhysicalType`
  694.  
  695. FunctionResult:Category=Column
  696. FunctionResult:Values=A.RDB$ARGUMENT_POSITION = `:RDB$RETURN_ARGUMENT`
  697. FunctionResult:Attrs=RDB$MECHANISM=Kind="Kind"::E:::VM=TFnParamKind
  698. FunctionResult:EAttrs=Text,New,Delete,Modify,Rename
  699. FunctionResult:Text:Get=`EPhysicalType``! ' ' =Kind`
  700.  
  701. BlobFilter:Category=Executable
  702. BlobFilter:Warning=Loss
  703. BlobFilter:EAttrs=Text,New,Delete,Modify,Rename,Save
  704. BlobFilter:Text:Get1=DECLARE FILTER `N \N`
  705. BlobFilter:Text:Get2= INPUT_TYPE `=InputType`  OUTPUT_TYPE `=OutputType``\N`
  706. BlobFilter:Text:Get3= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  707. BlobFilter:Delete:Text=DROP FILTER `O`
  708.  
  709. CheckConstraint:Category=Expression
  710. CheckConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'CHECK'
  711. CheckConstraint:Attrs:Q=Text=Memo::"Constraint Text":2:ER:PStripCheck
  712. CheckConstraint:AttrReference:Text1=select t.RDB$TRIGGER_SOURCE
  713. CheckConstraint:AttrReference:Text2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  714. CheckConstraint:AttrReference:Text3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  715. CheckConstraint:AttrReference:Text4=t.RDB$TRIGGER_TYPE=1 and
  716. CheckConstraint:AttrReference:Text5=c.RDB$CONSTRAINT_NAME=`OQ`
  717. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  718. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  719. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  720. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  721. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  722. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  723.  
  724. UniqueConstraint:Category=UniqueConstraint
  725. UniqueConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'UNIQUE'
  726. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  727. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  728. UniqueConstraint:Reference:"Columns"=RDB$INDEX_NAME
  729. UniqueConstraint:Reference:"Index"=RDB$INDEX_NAME
  730. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  731. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  732. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [IndexColumn:%s, %s:N] ')'`
  733. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  734.  
  735. PrimaryKey:Category=PrimaryKey
  736. PrimaryKey:Values=A.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  737. PrimaryKey:Objects1=T:P:1M::"Columns":IndexColumn
  738. PrimaryKey:Objects2=P:R:M1::"Index":Index:<>Index
  739. PrimaryKey:Reference:"Columns"=RDB$INDEX_NAME
  740. PrimaryKey:Reference:"Index"=RDB$INDEX_NAME
  741. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  742. PrimaryKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  743. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [IndexColumn:%s, %s:N] ')'`
  744. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  745.  
  746. ForeignKey:Category=ForeignKey
  747. ForeignKey:Values=A.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
  748. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  749. ForeignKey:Objects2=T:P:1M::"Columns":IndexColumn
  750. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  751. ForeignKey:Reference:"Index"=RDB$INDEX_NAME
  752. ForeignKey:Reference:"Columns"=RDB$INDEX_NAME
  753. ForeignKey:Reference:"Reference Table"=ReferenceTable
  754. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION=MatchOption
  755. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE=UpdateRule
  756. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE=DeleteRule
  757. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  758. ForeignKey:Attrs:R=Table::::ER
  759. ForeignKey:AttrReference:ReferenceTable1=select RDB$RELATION_NAME
  760. ForeignKey:AttrReference:ReferenceTable2=from RDB$REF_CONSTRAINTS A, RDB$RELATION_CONSTRAINTS B
  761. ForeignKey:AttrReference:ReferenceTable3=where A.RDB$CONST_NAME_UQ = B.RDB$CONSTRAINT_NAME
  762. ForeignKey:AttrReference:ReferenceTable4=and A.RDB$CONSTRAINT_NAME = `:RDB$CONSTRAINT_NAME`
  763. ForeignKey:AttrReference:MatchOption=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  764. ForeignKey:AttrReference:UpdateRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  765. ForeignKey:AttrReference:DeleteRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  766. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  767. ForeignKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  768. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [IndexColumn:%s, %s:N] ')'`
  769. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  770. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  771.  
  772. Trigger:Category=Executable
  773. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  774. Trigger:AttrReference:Text1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  775. Trigger:AttrReference:Text2=where RDB$TRIGGER_NAME=`OQ`
  776. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  777. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName` FOR `{<}N`
  778. Trigger:Text:Init2=AFTER UPDATE POSITION 0 AS`\N`BEGIN`\N`END
  779. Trigger:Text:Get1=CREATE TRIGGER `N` FOR `{<}N`
  780. Trigger:Text:Get2=`=Type` POSITION `=Position` `=Text`
  781. Trigger:Text:RE=CREATE\_+TRIGGER\_+(\w+)\_+FOR\_+(\w+)\_+(\w+\_\w+)\_+POSITION\_+(\w+)\_+(.*)
  782. Trigger:Text:Set=*N=1,2=`{<}N`,Type=3,Position=4,Text=5
  783. Trigger:Delete:Text=DROP TRIGGER `O`
  784.  
  785.  
  786.  
  787.